# -*- coding: UTF-8 -*-
"""
Create by Louis on 2019/7/28-11:55
"""
# __author__ = "Louis"
import xlrd

def read_xlrd(**kwargs):
    list=[]
    for key in kwargs:
        data = xlrd.open_workbook(kwargs[key])
        table = data.sheet_by_index(0)
        for rowNum in range(table.nrows):
                rowVale = table.row_values(rowNum)
                list.append(rowVale)
    return list
if __name__=="__main__":
    excelFile1 = './excelfile/excelzhong.xlsx'
    excelFile2 = './excelfile/excelzhong2.xlsx'
    list = read_xlrd(excelFile1=excelFile1,excelFile2=excelFile2)
    for i,j in enumerate(list):
        print(str(i+1)+":"+str(j))
    # read_xlrd(excelFile=excelFile1) #也可以这样写